package model;

public class DbSchema {
	public static String EMP_TABLE = "EMPLOYEE";
	public static String USR_TABLE = "USER";
	public static String ADMIN_TABLE = "ADMINISTRATOR";
	public static String USR_UNAME = "USERNAME";
	public static String USR_PWORD = "PASSWORD";
	
	
	
	public static String MEMBER_TABLE = "MEMBER";
	public static String MT_USERNAME = "USERNAME";
	public static String MT_FNAME = "FIRST_NAME";
	public static String MT_LNAME = "LAST_NAME";
	public static String MT_MINIT = "MIDDLE_INIT";
	public static String MT_ADDR = "ADDRESS";
	public static String MT_PHONE = "PHONE";
	public static String MT_EMAIL = "EMAIL";
	public static String MT_PLAN_NAME = "PLAN_NAME";
	public static String MT_CARD_NO = "CARD_NO";
	
	
	public static String DP_TABLE = "DRIVING_PLANS";
	public static String DP_NAME = "PLAN_NAME";
	public static String DP_MONTLY = "MTHLY_PMNT";
	public static String DP_DISCOUNT = "RENT_DSCNT";
	public static String DP_ANNUAL = "ANNUAL_FEE";
	
	public static String CC_TABLE = "CREDIT_CARD";
	public static String CC_NUM = "CARD_NO";
	public static String CC_NAME = "NAME_ON_CARD";
	public static String CC_BILL_ADD = "BILLING_ADDRESS";
	public static String CC_EXPRDATE = "EXPIR_DT";
	public static String CC_CVV = "CVV";
	
	public static String SRP_TABLE = "SERVICE_REQUEST_PROBLEM";
	public static String SRP_VIN = "RQST_VIN";
	public static String SRP_DTTM = "RQST_DTTM";
	public static String SRP_DESC = "RQST_DISC";
	
	public static String LOC_TABLE = "LOCATION";
	public static String LOC_NAME = "LOC_NM";
	public static String LOC_CAP = "CAPACITY";
	
	public static String CAR_TABLE = "CAR";
	public static String CAR_VIN = "VIN";
	public static String CAR_MODEL = "MDL_NM";
	public static String CAR_HOURLY = "HR_RTE";
	public static String CAR_DAILY = "DLY_RTE";
	public static String CAR_COLOR = "COLOR";
	public static String CAR_TYPE = "TYPE";
	public static String CAR_UNDER_MNTC = "MTC_FLG";
	public static String CAR_AUX = "AUX_IND";
	public static String CAR_BLUETOOTH = "BLUETH_IND";
	public static String CAR_TRANSMISSION = "TRNSMSN";
	public static String CAR_CAPACITY = "SEAT_CPCTY";
	public static String CAR_LOCATION = "LOC";
	
	
}
